Application of data warehouse technology in power analysis

نویسندگان

  • Xiaoguang Hong
  • Juan Chu
چکیده

Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensional database modeling and the presentation of multidimensional views. The system also builds power-oriented data warehouse using DB2 database, Warehouse Manager, Cube View and Alphablox of IBM. Then, this paper discusses the concrete applications of data warehouse in completing the extract, transform and load (ETL) of power data. The discussion includes the optimization of the system after creating the MQT tables using Cube View and the presentation of the analysis system. The system can help power corporations to do the decision-making.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Abstract: Data warehouse technology transforms the operational data store to general and compositive information

Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensiona...

متن کامل

A Solution to View Management to Build a Data Warehouse

Several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. These techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materializ...

متن کامل

Application of Big Data Analytics in Power Distribution Network

Smart grid enhances optimization in generation, distribution and consumption of the electricity by integrating information and communication technologies into the grid. Today, utilities are moving towards smart grid applications, most common one being deployment of smart meters in advanced metering infrastructure, and the first technical challenge they face is the huge volume of data generated ...

متن کامل

Non-linear modeling, analysis, design and simulation of a solid state power amplifier based on GaN technology for Ku band microwave application

A new non-linear method for design and analysis of solid state power amplifiers is presented and applied to an aluminum gallium nitride, gallium nitride (AlGaN-GaN) high electron-mobility transistor (HEMTs) on silicon-carbide (SiC) substrate for Ku band (12.4 13.6 GHz) applications. With combining output power of 8 transistors, maximum output power of 46.3 dBm (42.6 W), PAE of 43% and linear ga...

متن کامل

Data Warehouse Design and Optimization for Drilling Engineering

With the development of petroleum informatization and increase of drilling data, data storage, analysis and integration is attached to the key planning process. Therefore, a solution is needed which combines the data integration, management, analysis and decision support. Data warehouse is one of the hot topics in computer technology application, which has solved the problem of data using after...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2006